package com.coolliuan.mapper;

import com.coolliuan.pojo.Employee;
import org.apache.ibatis.annotations.Param;

import java.util.*;

public interface EmployeeMapper {
    Employee queryById(Integer id);

    int deleteById(Integer id);

    List<Employee> queryBySalary(Double salary);

    int insertEmp(Employee employee);

    List<Employee> queryByNameAndSalary(@Param("name") String name, @Param("salary") Double salary);

    int insertEmpMap(Map data);

    Map<String, Object> selectEmpNameAndMaxSalary();

    List<String> queryNamesBySalary(Double salary);

    List<Employee> queryAll();
}
